package 实训二;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

import java.sql.Timestamp;

@AllArgsConstructor
@NoArgsConstructor
@Data
public class TrafficPageViewBean {
    private Timestamp stt;
    private Timestamp edt;
    private String vc;
    private String ch;
    private String ar;
    private String isNew;
    private Long uvCt;
    private Long svCt;
    private Long pvCt;
    private Long durSum;
    private Long ujCt;
    private Long ts;



//    CREATE TABLE gmall.dws_traffic_vc_ch_page_window
//             (
//                            `stt` DateTime,
//                             `edt` DateTime,
//                             `vc` String,
//                             `ch` String,
//                             `ar` String,
//                             `isNew` String,
//                             `uvCt` UInt64,
//                             `svCt` UInt64,
//                             `pvCt` UInt64,
//                             `durSum` UInt64,
//                             `ujCt` UInt64,
//                             `ts` UInt64
//             )
//            ENGINE = ReplacingMergeTree(ts)
//     PARTITION BY toYYYYMMDD(stt)
//     ORDER BY (stt, edt,vc,ch,ar,isNew)
//     SETTINGS index_granularity = 8192;

}
